/**
 * 
 */
package com.magus.project.yddemo.service;

import java.sql.Date;
import java.util.ArrayList;
import java.util.Calendar;
import java.util.List;

import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFCellStyle;
import org.apache.poi.hssf.usermodel.HSSFFont;
import org.apache.poi.hssf.usermodel.HSSFRichTextString;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.util.CellRangeAddress;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.data.jpa.domain.Specification;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import com.magus.framework.core.persistence.JpaSearchUtils;
import com.magus.framework.core.persistence.SearchFilter;
import com.magus.framework.core.repository.BaseRepository;
import com.magus.framework.core.service.BaseService;
import com.magus.project.yddemo.entity.IndicatorMapperData;
import com.magus.project.yddemo.entity.IndicatorMapperReport2;
import com.magus.project.yddemo.repository.IndicatorMapperReport2Repository;

/**
 * @author wenyu.han
 * @date 2018-04-02 08:56:57
 */
@Service
@Transactional(readOnly = true)
public class IndicatorMapperReport2Service extends BaseService<IndicatorMapperReport2, String> {

	@Autowired
	private IndicatorMapperReport2Repository reportRepository;

	@Autowired
	private IndicatorMapperDataService mapperDataService;

	@Override
	protected BaseRepository<IndicatorMapperReport2, String> getBaseRepository() {
		return reportRepository;
	}

	// 数据起始行号
	static final Integer ROW_INDEX = 13;

	/**
	 * 每行的固定列用##符号分开
	 */
	private static final String[] ALL_ROW_NAME = new String[] { "广东粤电新丰江发电有限责任公司#1机组##01001##75108654-6",
			"广东粤电新丰江发电有限责任公司#2机组##01002##75108654-6", "广东粤电新丰江发电有限责任公司#3机组##01003##75108654-6",
			"广东粤电新丰江发电有限责任公司#4机组##01004##75108654-6", "广东粤电枫树坝发电有限责任公司#1机组##01005##75105009－2",
			"广东粤电枫树坝发电有限责任公司#2机组##01006##75105009－2", "广东粤电青溪发电有限责任公司#1机组##01007##19642347-7",
			"广东粤电青溪发电有限责任公司#2机组##01008##19642347-7", "广东粤电青溪发电有限责任公司#3机组##01009##19642347-7",
			"广东粤电青溪发电有限责任公司#4机组##01010##19642347-7", "广东粤电长湖发电有限责任公司#1机组##01011##197770796",
			"广东粤电长湖发电有限责任公司#2机组##01012##197770796", "广东粤电南水发电有限责任公司#1机组##01013##x1746601-8",
			" 广东粤电南水发电有限责任公司#2机组##01014##x1746601-8", "广东粤电南水发电有限责任公司#3机组##01015##x1746601-8",
			"广东粤电长潭发电有限责任公司#1机组##01016##75205556-5", "广东粤电长潭发电有限责任公司#2机组##01017##75205556-5",
			"广东粤电长潭发电有限责任公司#3机组##01018##19667395-1", "广东粤电长潭发电有限责任公司#4机组##01019##19667395-1",
			"广东粤电流溪河发电有限责任公司#1机组##01020##19667395-1", "广东粤电流溪河发电有限责任公司#2机组##01021##19667395-1",
			"广东粤电流溪河发电有限责任公司#3机组##01022##19667395-1", "广东粤电流溪河发电有限责任公司#4机组##01023##19033515-0",
			"大埔县梅江蓬辣滩水电站有限公司#1机组##01024##19033515-0", "大埔县梅江蓬辣滩水电站有限公司#2机组##01025##19033515-0",
			"大埔县梅江蓬辣滩水电站有限公司#3机组##01026##19033515-0", "大埔县梅江蓬辣滩水电站有限公司#4机组##01027##73989594-9",
			"天生桥一级水电开发有限责任公司水力发电厂#1机组##01028##73989594-9", "天生桥一级水电开发有限责任公司水力发电厂#2机组##01029##73989594-9",
			"天生桥一级水电开发有限责任公司水力发电厂#3机组##01030##73989594-9", "天生桥一级水电开发有限责任公司水力发电厂#4机组##01031##73096079-1",
			"临沧粤电能源有限公司新塘房电厂#1机组##01032##77048814-5", "临沧粤电能源有限公司新塘房电厂#2机组##01033##77048814-5",
			"临沧粤电能源有限公司新塘房电厂#3机组##01034##77048814-5", "临沧粤电能源有限公司南荣田电厂#1机组##01035##77048814-5",
			"临沧粤电能源有限公司南荣田电厂#2机组##01036##77048814-5", "临沧粤电能源有限公司南荣田电厂#3机组##01037##77048814-5",
			"临沧粤电能源有限公司南荣田电厂#4机组##01038##77048814-5", "广东电力发展股份有限公司沙角A电厂#1机组##01039##73148621-9",
			"广东电力发展股份有限公司沙角A电厂#2机组##01040##73148621-9", "广东电力发展股份有限公司沙角A电厂#3机组##01041##73148621-9",
			"广东电力发展股份有限公司沙角A电厂#4机组##01042##73148621-9", "广东电力发展股份有限公司沙角A电厂#5机组##01043##73148621-9",
			"广东粤电集团有限公司沙角C电厂#1机组##01044##74369834-X", "广东粤电集团有限公司沙角C电厂#2机组##01045##74369834-X",
			"广东粤电集团有限公司沙角C电厂#3机组##01046##74369834-X", "广东省粤电集团有限公司珠海发电厂#1机组##01047##70812907—X",
			"广东省粤电集团有限公司珠海发电厂#2机组##01048##70812907—X", "广东粤华发电有限责任公司#1机组##01049##19032084-8",
			"广东粤华发电有限责任公司#2机组##01050##19032084-8", "湛江电力有限公司#1机组##01051##23210093-2",
			" 湛江电力有限公司#2机组##01052##23210093-2", "湛江电力有限公司#3机组##01053##23210093-2", " 湛江电力有限公司#4机组##01054##23210093-2",
			"韶关粤江发电有限责任公司#1机组##01055##70752208-0", "韶关粤江发电有限责任公司#2机组##01056##70752208-0",
			"韶关粤江发电有限责任公司#10机组##01057##70752208-0", "韶关粤江发电有限责任公司#11机组##01058##70752208-0",
			" 茂名臻能发电有限公司#5机组##01059##76656459-8", " 茂名臻能发电有限公司#6机组##01060##76656459-8",
			" 茂名臻能发电有限公司#7机组##01061##76656459-8", " 广东粤嘉电力有限公司#5机组##01062##61741361-4",
			" 广东粤嘉电力有限公司#6机组##01063##61741361-4", " 广东粤电云河发电有限公司#1机组##01064##69475944-0",
			" 广东粤电云河发电有限公司#2机组##01065##69475944-0", " 广东粤电云河发电有限公司#5机组##01066##69475944-0",
			" 广东粤电云河发电有限公司#6机组##01067##69475944-0", " 广东省粤泷发电有限责任公司#1机组##01068##61785108-3",
			" 广东省粤泷发电有限责任公司#2机组##01069##61785108-3", " 广东珠海金湾发电有限公司#1机组##01070##71785911－1",
			" 广东珠海金湾发电有限公司#2机组##01071##71785911－1", " 广东红海湾发电有限公司#1机组##01072##77307022-X",
			" 广东红海湾发电有限公司#2机组##01073##77307022-X", " 广东红海湾发电有限公司#3机组##01074##77307022-X",
			" 广东红海湾发电有限公司#4机组##01075##77307022-X", " 广东粤电靖海发电有限公司#1机组##01076##76061818-8",
			" 广东粤电靖海发电有限公司#2机组##01077##76061818-8", " 广东粤电靖海发电有限公司#3机组##01078##76061818-8",
			" 广东粤电靖海发电有限公司#4机组##01079##76061818-8", " 广东惠州平海发电厂有限公司#1机组##01080##791172465",
			" 广东惠州平海发电厂有限公司#2机组##01081##791172465", " 贵州粤黔电力有限责任公司盘南电厂#1机组##01082##61806419-6",
			" 贵州粤黔电力有限责任公司盘南电厂#2机组##01083##61806419-6", " 贵州粤黔电力有限责任公司盘南电厂#3机组##01084##61806419-6",
			" 贵州粤黔电力有限责任公司盘南电厂#4机组##01085##61806419-6", " 湛江中粤能源有限公司#1机组##01086##74367331-0",
			" 湛江中粤能源有限公司#2机组##01087##74367331-0", "广东粤电大埔发电有限公司#1机组##01088##06145024-0",
			"广东粤电大埔发电有限公司#2机组##01089##06145024-0", "广东惠州天然气发电有限公司#1##01090##791172465",
			"广东惠州天然气发电有限公司#2##01091##791172465", "广东惠州天然气发电有限公司#3##01092##791172465",
			" 深圳市广前电力有限公司#1机组##01093##76380066-3", " 深圳市广前电力有限公司#2机组##01094##76380066-3",
			" 深圳市广前电力有限公司#3机组##01095##76380066-3", " 广东粤电湛江生物质发电有限公司#1机组##01096##68056594-4",
			" 广东粤电湛江生物质发电有限公司#2机组##01097##68056594-4", "广东粤电石碑山风能开发有限公司##01098##791172465",
			"广东粤电湛江风力发电有限公司##01099##01099", "惠来风力发电有限公司##01100##70762183-9", "广东粤电电白风电有限公司##01101##71911813",
			"贵州粤电六盘水综合能源有限公司长山菁风电场##01102##098548129", "贵州粤电遵义风能有限公司仙人山风电场##01103##098956288",
			"贵州粤电石阡风能有限公司大顶山风电场##01104##085652306", "广州开发区粤电新能源有限公司（太阳能）##01105##082711868",
			"广东粤电阳西新能源有限公司（太阳能）##01106##MA4UM48Y1" };

	/**
	 * ########指标按照报表行顺序进行排列######## ########如果指标明细中为空的指标，用""标识######## 期末发电设备容量
	 */
	private static final String[] QMFDSB_ALL = new String[] { "XFJ1_MPRL_M_M_M_SUM_M_CTST",
			"XFJ2_MPRL_M_M_M_SUM_M_CTST", "XFJ3_MPRL_M_M_M_SUM_M_CTST", "XFJ4_MPRL_M_M_M_SUM_M_CTST",
			"FSB1_MPRL_M_M_M_SUM_M_CTST", "FSB2_MPRL_M_M_M_SUM_M_CTST", "QXH1_MPRL_M_M_M_SUM_M_CTST",
			"QXH2_MPRL_M_M_M_SUM_M_CTST", "QXH3_MPRL_M_M_M_SUM_M_CTST", "QXH4_MPRL_M_M_M_SUM_M_CTST",
			"CHH1_MPRL_M_M_M_SUM_M_CTST", "CHH2_MPRL_M_M_M_SUM_M_CTST", "NSH1_MPRL_M_M_M_SUM_M_CTST",
			"NSH2_MPRL_M_M_M_SUM_M_CTST", "NSH3_MPRL_M_M_M_SUM_M_CTST", "CTH1_MPRL_M_M_M_SUM_M_CTST",
			"CTH2_MPRL_M_M_M_SUM_M_CTST", "CTH3_MPRL_M_M_M_SUM_M_CTST", "CTH4_MPRL_M_M_M_SUM_M_CTST",
			"LXH1_MPRL_M_M_M_SUM_M_CTST", "LXH2_MPRL_M_M_M_SUM_M_CTST", "LXH3_MPRL_M_M_M_SUM_M_CTST",
			"LXH4_MPRL_M_M_M_SUM_M_CTST", "PLT1_MPRL_M_M_M_SUM_M_CTST", "PLT2_MPRL_M_M_M_SUM_M_CTST",
			"PLT3_MPRL_M_M_M_SUM_M_CTST", "PLT4_MPRL_M_M_M_SUM_M_CTST", "TSQ1_MPRL_M_M_M_SUM_M_CTST",
			"TSQ2_MPRL_M_M_M_SUM_M_CTST", "TSQ3_MPRL_M_M_M_SUM_M_CTST", "TSQ4_MPRL_M_M_M_SUM_M_CTST",
			"LCC1_MPRL_M_M_M_SUM_M_CTST", "LCC2_MPRL_M_M_M_SUM_M_CTST", "LCC3_MPRL_M_M_M_SUM_M_CTST", "", "", "", "",
			"SJA1_MPRL_M_M_M_SUM_M_CTST", "SJA2_MPRL_M_M_M_SUM_M_CTST", "SJA3_MPRL_M_M_M_SUM_M_CTST",
			"SJA4_MPRL_M_M_M_SUM_M_CTST", "SJA5_MPRL_M_M_M_SUM_M_CTST", "SJC1_MPRL_M_M_M_SUM_M_CTST",
			"SJC2_MPRL_M_M_M_SUM_M_CTST", "SJC3_MPRL_M_M_M_SUM_M_CTST", "ZHP1_MPRL_M_M_M_SUM_M_CTST",
			"ZHP2_MPRL_M_M_M_SUM_M_CTST", "HPP1_MPRL_M_M_M_SUM_M_CTST", "HPP2_MPRL_M_M_M_SUM_M_CTST",
			"ZJP1_MPRL_M_M_M_SUM_M_CTST", "ZJP2_MPRL_M_M_M_SUM_M_CTST", "ZJP3_MPRL_M_M_M_SUM_M_CTST",
			"ZJP4_MPRL_M_M_M_SUM_M_CTST", "SGY1_MPRL_M_M_M_SUM_M_CTST", "SGY2_MPRL_M_M_M_SUM_M_CTST",
			"SGYA_MPRL_M_M_M_SUM_M_CTST", "SGYB_MPRL_M_M_M_SUM_M_CTST", "MMP5_MPRL_M_M_M_SUM_M_CTST",
			"MMP6_MPRL_M_M_M_SUM_M_CTST", "MMP7_MPRL_M_M_M_SUM_M_CTST", "MXP5_MPRL_M_M_M_SUM_M_CTST",
			"MXP6_MPRL_M_M_M_SUM_M_CTST", "YFA1_MPRL_M_M_M_SUM_M_CTST", "YFA2_MPRL_M_M_M_SUM_M_CTST",
			"YFC5_MPRL_M_M_M_SUM_M_CTST", "YFC6_MPRL_M_M_M_SUM_M_CTST", "YLP1_MPRL_M_M_M_SUM_M_CTST",
			"YLP2_MPRL_M_M_M_SUM_M_CTST", "JWP3_MPRL_M_M_M_SUM_M_CTST", "JWP4_MPRL_M_M_M_SUM_M_CTST",
			"HHW1_MPRL_M_M_M_SUM_M_CTST", "HHW2_MPRL_M_M_M_SUM_M_CTST", "HHW3_MPRL_M_M_M_SUM_M_CTST",
			"HHW4_MPRL_M_M_M_SUM_M_CTST", "JHP1_MPRL_M_M_M_SUM_M_CTST", "JHP2_MPRL_M_M_M_SUM_M_CTST",
			"JHP3_MPRL_M_M_M_SUM_M_CTST", "JHP4_MPRL_M_M_M_SUM_M_CTST", "PHP1_MPRL_M_M_M_SUM_M_CTST",
			"PHP2_MPRL_M_M_M_SUM_M_CTST", "PNP1_MPRL_M_M_M_SUM_M_CTST", "PNP2_MPRL_M_M_M_SUM_M_CTST",
			"PNP3_MPRL_M_M_M_SUM_M_CTST", "PNP4_MPRL_M_M_M_SUM_M_CTST", "TSP1_MPRL_M_M_M_SUM_M_CTST",
			"TSP2_MPRL_M_M_M_SUM_M_CTST", "DPP1_MPRL_M_M_M_SUM_M_CTST", "DPP2_MPRL_M_M_M_SUM_M_CTST",
			"HZL1_MPRL_M_M_M_SUM_M_CTST", "HZL2_MPRL_M_M_M_SUM_M_CTST", "HZL3_MPRL_M_M_M_SUM_M_CTST",
			"GQL1_MPRL_M_M_M_SUM_M_CTST", "GQL2_MPRL_M_M_M_SUM_M_CTST", "GQL3_MPRL_M_M_M_SUM_M_CTST",
			"SWF1_MPRL_M_M_M_SUM_M_CTST", "SWF2_MPRL_M_M_M_SUM_M_CTST", "SBS1_MPRL_M_M_M_SUM_M_CTST",
			"ZJW_MPRL_M_M_M_SUM_M_CTST", "HLW_MPRL_M_M_M_SUM_M_CTST", "DBW_MPRL_M_M_M_SUM_M_CTST",
			"PXW_MPRL_M_M_M_SUM_M_CTST", "ZYW_MPRL_M_M_M_SUM_M_CTST", "SQW_MPRL_M_M_M_SUM_M_CTST",
			"KFE_MPRL_M_M_M_SUM_M_CTST", "YXX_MPRL_M_M_M_SUM_M_CTST" };

	/**
	 * 其中：供热设备容量(千瓦)
	 */
	private static final String[] GRSB_ALL = new String[] { "", "", "", "", "", "", "", "", "", "", "", "", "", "", "",
			"", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "",
			"", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "",
			"MMP5_MPRL_M_M_M_SUM_M_CTST_MPRL_M_M_M_SUM_M_CTST", "MMP6_MPRL_M_M_M_SUM_M_CTST_MPRL_M_M_M_SUM_M_CTST",
			"MMP7_MPRL_M_M_M_SUM_M_CTST_MPRL_M_M_M_SUM_M_CTST", "", "", "", "", "", "", "", "", "", "", "", "", "", "",
			"", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "",
			"", "", "", "" };

	/**
	 * 发电量(万千瓦时)
	 */
	static final String[] FDL_ALL = new String[] { "XFJ1_FDL_M_M_M_SUM_M_MANL", "XFJ2_FDL_M_M_M_SUM_M_MANL",
			"XFJ3_FDL_M_M_M_SUM_M_MANL", "XFJ4_FDL_M_M_M_SUM_M_MANL", "FSB1_FDL_M_M_M_SUM_M_MANL",
			"FSB2_FDL_M_M_M_SUM_M_MANL", "QXH1_FDL_M_M_M_SUM_M_MANL", "QXH2_FDL_M_M_M_SUM_M_MANL",
			"QXH3_FDL_M_M_M_SUM_M_MANL", "QXH4_FDL_M_M_M_SUM_M_MANL", "CHH1_FDL_M_M_M_SUM_M_MANL",
			"CHH2_FDL_M_M_M_SUM_M_MANL", "NSH1_FDL_M_M_M_SUM_M_MANL", "NSH2_FDL_M_M_M_SUM_M_MANL",
			"NSH3_FDL_M_M_M_SUM_M_MANL", "CTH1_FDL_M_M_M_SUM_M_MANL", "CTH2_FDL_M_M_M_SUM_M_MANL",
			"CTH3_FDL_M_M_M_SUM_M_MANL", "CTH4_FDL_M_M_M_SUM_M_MANL", "LXH1_FDL_M_M_M_SUM_M_MANL",
			"LXH2_FDL_M_M_M_SUM_M_MANL", "LXH3_FDL_M_M_M_SUM_M_MANL", "LXH4_FDL_M_M_M_SUM_M_MANL",
			"PLT1_FDL_M_M_M_SUM_M_MANL", "PLT2_FDL_M_M_M_SUM_M_MANL", "PLT3_FDL_M_M_M_SUM_M_MANL",
			"PLT4_FDL_M_M_M_SUM_M_MANL", "TSQ1_FDL_M_M_M_SUM_M_MANL", "TSQ2_FDL_M_M_M_SUM_M_MANL",
			"TSQ3_FDL_M_M_M_SUM_M_MANL", "TSQ4_FDL_M_M_M_SUM_M_MANL", "LCC1_FDL_M_M_M_SUM_M_MANL",
			"LCC2_FDL_M_M_M_SUM_M_MANL", "LCC3_FDL_M_M_M_SUM_M_MANL", "", "", "", "", "SJA1_FDL_M_M_M_SUM_M_MANL",
			"SJA2_FDL_M_M_M_SUM_M_MANL", "SJA3_FDL_M_M_M_SUM_M_MANL", "SJA4_FDL_M_M_M_SUM_M_MANL",
			"SJA5_FDL_M_M_M_SUM_M_MANL", "SJC1_FDL_M_M_M_SUM_M_MANL", "SJC2_FDL_M_M_M_SUM_M_MANL",
			"SJC3_FDL_M_M_M_SUM_M_MANL", "ZHP1_FDL_M_M_M_SUM_M_MANL", "ZHP2_FDL_M_M_M_SUM_M_MANL",
			"HPP1_FDL_M_M_M_SUM_M_MANL", "HPP2_FDL_M_M_M_SUM_M_MANL", "ZJP1_FDL_M_M_M_SUM_M_MANL",
			"ZJP2_FDL_M_M_M_SUM_M_MANL", "ZJP3_FDL_M_M_M_SUM_M_MANL", "ZJP4_FDL_M_M_M_SUM_M_MANL",
			"SGY1_FDL_M_M_M_SUM_M_MANL", "SGY2_FDL_M_M_M_SUM_M_MANL", "SGYA_FDL_M_M_M_SUM_M_MANL",
			"SGYB_FDL_M_M_M_SUM_M_MANL", "MMP5_FDL_M_M_M_SUM_M_MANL", "MMP6_FDL_M_M_M_SUM_M_MANL",
			"MMP7_FDL_M_M_M_SUM_M_MANL", "MXP5_FDL_M_M_M_SUM_M_MANL", "MXP6_FDL_M_M_M_SUM_M_MANL",
			"YFA1_FDL_M_M_M_SUM_M_MANL", "YFA2_FDL_M_M_M_SUM_M_MANL", "YFC5_FDL_M_M_M_SUM_M_MANL",
			"YFC6_FDL_M_M_M_SUM_M_MANL", "YLP1_FDL_M_M_M_SUM_M_MANL", "YLP2_FDL_M_M_M_SUM_M_MANL",
			"JWP3_FDL_M_M_M_SUM_M_MANL", "JWP4_FDL_M_M_M_SUM_M_MANL", "HHW1_FDL_M_M_M_SUM_M_MANL",
			"HHW2_FDL_M_M_M_SUM_M_MANL", "HHW3_FDL_M_M_M_SUM_M_MANL", "HHW4_FDL_M_M_M_SUM_M_MANL",
			"JHP1_FDL_M_M_M_SUM_M_MANL", "JHP2_FDL_M_M_M_SUM_M_MANL", "JHP3_FDL_M_M_M_SUM_M_MANL",
			"JHP4_FDL_M_M_M_SUM_M_MANL", "PHP1_FDL_M_M_M_SUM_M_MANL", "PHP2_FDL_M_M_M_SUM_M_MANL",
			"PNP1_FDL_M_M_M_SUM_M_MANL", "PNP2_FDL_M_M_M_SUM_M_MANL", "PNP3_FDL_M_M_M_SUM_M_MANL",
			"PNP4_FDL_M_M_M_SUM_M_MANL", "TSP1_FDL_M_M_M_SUM_M_MANL", "TSP2_FDL_M_M_M_SUM_M_MANL",
			"DPP1_FDL_M_M_M_SUM_M_MANL", "DPP2_FDL_M_M_M_SUM_M_MANL", "HZL1_FDL_M_M_M_SUM_M_MANL",
			"HZL2_FDL_M_M_M_SUM_M_MANL", "HZL3_FDL_M_M_M_SUM_M_MANL", "GQL1_FDL_M_M_M_SUM_M_MANL",
			"GQL2_FDL_M_M_M_SUM_M_MANL", "GQL3_FDL_M_M_M_SUM_M_MANL", "SWF1_FDL_M_M_M_SUM_M_MANL",
			"SWF2_FDL_M_M_M_SUM_M_MANL", "SBS1_FDL_M_M_M_SUM_M_MANL", "ZJW_FDL_M_M_M_SUM_M_MANL",
			"HLW_FDL_M_M_M_SUM_M_MANL", "DBW_FDL_M_M_M_SUM_M_MANL", "PXW_FDL_M_M_M_SUM_M_MANL",
			"ZYW_FDL_M_M_M_SUM_M_MANL", "SQW_FDL_M_M_M_SUM_M_MANL", "KFE_FDL_M_M_M_SUM_M_MANL",
			"YXX_FDL_M_M_M_SUM_M_MANL" };

	/**
	 * 平均设备容量(千瓦)
	 */
	static final String[] PJSB_ALL = new String[] { "XFJ1_MPRL_M_M_M_SUM_M_CTST", "XFJ2_MPRL_M_M_M_SUM_M_CTST",
			"XFJ3_MPRL_M_M_M_SUM_M_CTST", "XFJ4_MPRL_M_M_M_SUM_M_CTST", "FSB1_MPRL_M_M_M_SUM_M_CTST",
			"FSB2_MPRL_M_M_M_SUM_M_CTST", "QXH1_MPRL_M_M_M_SUM_M_CTST", "QXH2_MPRL_M_M_M_SUM_M_CTST",
			"QXH3_MPRL_M_M_M_SUM_M_CTST", "QXH4_MPRL_M_M_M_SUM_M_CTST", "CHH1_MPRL_M_M_M_SUM_M_CTST",
			"CHH2_MPRL_M_M_M_SUM_M_CTST", "NSH1_MPRL_M_M_M_SUM_M_CTST", "NSH2_MPRL_M_M_M_SUM_M_CTST",
			"NSH3_MPRL_M_M_M_SUM_M_CTST", "CTH1_MPRL_M_M_M_SUM_M_CTST", "CTH2_MPRL_M_M_M_SUM_M_CTST",
			"CTH3_MPRL_M_M_M_SUM_M_CTST", "CTH4_MPRL_M_M_M_SUM_M_CTST", "LXH1_MPRL_M_M_M_SUM_M_CTST",
			"LXH2_MPRL_M_M_M_SUM_M_CTST", "LXH3_MPRL_M_M_M_SUM_M_CTST", "LXH4_MPRL_M_M_M_SUM_M_CTST",
			"PLT1_MPRL_M_M_M_SUM_M_CTST", "PLT2_MPRL_M_M_M_SUM_M_CTST", "PLT3_MPRL_M_M_M_SUM_M_CTST",
			"PLT4_MPRL_M_M_M_SUM_M_CTST", "TSQ1_MPRL_M_M_M_SUM_M_CTST", "TSQ2_MPRL_M_M_M_SUM_M_CTST",
			"TSQ3_MPRL_M_M_M_SUM_M_CTST", "TSQ4_MPRL_M_M_M_SUM_M_CTST", "LCC1_MPRL_M_M_M_SUM_M_CTST",
			"LCC2_MPRL_M_M_M_SUM_M_CTST", "LCC3_MPRL_M_M_M_SUM_M_CTST", "", "", "", "", "SJA1_MPRL_M_M_M_SUM_M_CTST",
			"SJA2_MPRL_M_M_M_SUM_M_CTST", "SJA3_MPRL_M_M_M_SUM_M_CTST", "SJA4_MPRL_M_M_M_SUM_M_CTST",
			"SJA5_MPRL_M_M_M_SUM_M_CTST", "SJC1_MPRL_M_M_M_SUM_M_CTST", "SJC2_MPRL_M_M_M_SUM_M_CTST",
			"SJC3_MPRL_M_M_M_SUM_M_CTST", "ZHP1_MPRL_M_M_M_SUM_M_CTST", "ZHP2_MPRL_M_M_M_SUM_M_CTST",
			"HPP1_MPRL_M_M_M_SUM_M_CTST", "HPP2_MPRL_M_M_M_SUM_M_CTST", "ZJP1_MPRL_M_M_M_SUM_M_CTST",
			"ZJP2_MPRL_M_M_M_SUM_M_CTST", "ZJP3_MPRL_M_M_M_SUM_M_CTST", "ZJP4_MPRL_M_M_M_SUM_M_CTST",
			"SGY1_MPRL_M_M_M_SUM_M_CTST", "SGY2_MPRL_M_M_M_SUM_M_CTST", "SGYA_MPRL_M_M_M_SUM_M_CTST",
			"SGYB_MPRL_M_M_M_SUM_M_CTST", "MMP5_MPRL_M_M_M_SUM_M_CTST", "MMP6_MPRL_M_M_M_SUM_M_CTST",
			"MMP7_MPRL_M_M_M_SUM_M_CTST", "MXP5_MPRL_M_M_M_SUM_M_CTST", "MXP6_MPRL_M_M_M_SUM_M_CTST",
			"YFA1_MPRL_M_M_M_SUM_M_CTST", "YFA2_MPRL_M_M_M_SUM_M_CTST", "YFC5_MPRL_M_M_M_SUM_M_CTST",
			"YFC6_MPRL_M_M_M_SUM_M_CTST", "YLP1_MPRL_M_M_M_SUM_M_CTST", "YLP2_MPRL_M_M_M_SUM_M_CTST",
			"JWP3_MPRL_M_M_M_SUM_M_CTST", "JWP4_MPRL_M_M_M_SUM_M_CTST", "HHW1_MPRL_M_M_M_SUM_M_CTST",
			"HHW2_MPRL_M_M_M_SUM_M_CTST", "HHW3_MPRL_M_M_M_SUM_M_CTST", "HHW4_MPRL_M_M_M_SUM_M_CTST",
			"JHP1_MPRL_M_M_M_SUM_M_CTST", "JHP2_MPRL_M_M_M_SUM_M_CTST", "JHP3_MPRL_M_M_M_SUM_M_CTST",
			"JHP4_MPRL_M_M_M_SUM_M_CTST", "PHP1_MPRL_M_M_M_SUM_M_CTST", "PHP2_MPRL_M_M_M_SUM_M_CTST",
			"PNP1_MPRL_M_M_M_SUM_M_CTST", "PNP2_MPRL_M_M_M_SUM_M_CTST", "PNP3_MPRL_M_M_M_SUM_M_CTST",
			"PNP4_MPRL_M_M_M_SUM_M_CTST", "TSP1_MPRL_M_M_M_SUM_M_CTST", "TSP2_MPRL_M_M_M_SUM_M_CTST",
			"DPP1_MPRL_M_M_M_SUM_M_CTST", "DPP2_MPRL_M_M_M_SUM_M_CTST", "HZL1_MPRL_M_M_M_SUM_M_CTST",
			"HZL2_MPRL_M_M_M_SUM_M_CTST", "HZL3_MPRL_M_M_M_SUM_M_CTST", "GQL1_MPRL_M_M_M_SUM_M_CTST",
			"GQL2_MPRL_M_M_M_SUM_M_CTST", "GQL3_MPRL_M_M_M_SUM_M_CTST", "SWF1_MPRL_M_M_M_SUM_M_CTST",
			"SWF2_MPRL_M_M_M_SUM_M_CTST", "SBS1_MPRL_M_M_M_SUM_M_CTST", "ZJW_MPRL_M_M_M_SUM_M_CTST",
			"HLW_MPRL_M_M_M_SUM_M_CTST", "DBW_MPRL_M_M_M_SUM_M_CTST", "PXW_MPRL_M_M_M_SUM_M_CTST",
			"ZYW_MPRL_M_M_M_SUM_M_CTST", "SQW_MPRL_M_M_M_SUM_M_CTST", "KFE_MPRL_M_M_M_SUM_M_CTST",
			"YXX_MPRL_M_M_M_SUM_M_CTST" };

	/**
	 * 发电厂用电量(万千瓦时)
	 */
	static final String[] FDCYD_ALL = new String[] { "XFJ1_SCCYDL_M_M_M_SUM_M_MANL", "XFJ2_SCCYDL_M_M_M_SUM_M_MANL",
			"XFJ3_SCCYDL_M_M_M_SUM_M_MANL", "XFJ4_SCCYDL_M_M_M_SUM_M_MANL", "FSB1_SCCYDL_M_M_M_SUM_M_MANL",
			"FSB2_SCCYDL_M_M_M_SUM_M_MANL", "QXH1_SCCYDL_M_M_M_SUM_M_MANL", "QXH2_SCCYDL_M_M_M_SUM_M_MANL",
			"QXH3_SCCYDL_M_M_M_SUM_M_MANL", "QXH4_SCCYDL_M_M_M_SUM_M_MANL", "CHH1_SCCYDL_M_M_M_SUM_M_MANL",
			"CHH2_SCCYDL_M_M_M_SUM_M_MANL", "NSH1_SCCYDL_M_M_M_SUM_M_MANL", "NSH2_SCCYDL_M_M_M_SUM_M_MANL",
			"NSH3_SCCYDL_M_M_M_SUM_M_MANL", "CTH1_SCCYDL_M_M_M_SUM_M_MANL", "CTH2_SCCYDL_M_M_M_SUM_M_MANL",
			"CTH3_SCCYDL_M_M_M_SUM_M_MANL", "CTH4_SCCYDL_M_M_M_SUM_M_MANL", "LXH1_SCCYDL_M_M_M_SUM_M_MANL",
			"LXH2_SCCYDL_M_M_M_SUM_M_MANL", "LXH3_SCCYDL_M_M_M_SUM_M_MANL", "LXH4_SCCYDL_M_M_M_SUM_M_MANL",
			"PLT1_SCCYDL_M_M_M_SUM_M_MANL", "PLT2_SCCYDL_M_M_M_SUM_M_MANL", "PLT3_SCCYDL_M_M_M_SUM_M_MANL",
			"PLT4_SCCYDL_M_M_M_SUM_M_MANL", "TSQ1_SCCYDL_M_M_M_SUM_M_MANL", "TSQ2_SCCYDL_M_M_M_SUM_M_MANL",
			"TSQ3_SCCYDL_M_M_M_SUM_M_MANL", "TSQ4_SCCYDL_M_M_M_SUM_M_MANL", "LCC1_SCCYDL_M_M_M_SUM_M_MANL",
			"LCC2_SCCYDL_M_M_M_SUM_M_MANL", "LCC3_SCCYDL_M_M_M_SUM_M_MANL", "", "", "", "",
			"SJA1_SCCYDL_M_M_M_SUM_M_MANL", "SJA2_SCCYDL_M_M_M_SUM_M_MANL", "SJA3_SCCYDL_M_M_M_SUM_M_MANL",
			"SJA4_SCCYDL_M_M_M_SUM_M_MANL", "SJA5_SCCYDL_M_M_M_SUM_M_MANL", "SJC1_SCCYDL_M_M_M_SUM_M_MANL",
			"SJC2_SCCYDL_M_M_M_SUM_M_MANL", "SJC3_SCCYDL_M_M_M_SUM_M_MANL", "ZHP1_SCCYDL_M_M_M_SUM_M_MANL",
			"ZHP2_SCCYDL_M_M_M_SUM_M_MANL", "HPP1_SCCYDL_M_M_M_SUM_M_MANL", "HPP2_SCCYDL_M_M_M_SUM_M_MANL",
			"ZJP1_SCCYDL_M_M_M_SUM_M_MANL", "ZJP2_SCCYDL_M_M_M_SUM_M_MANL", "ZJP3_SCCYDL_M_M_M_SUM_M_MANL",
			"ZJP4_SCCYDL_M_M_M_SUM_M_MANL", "SGY1_SCCYDL_M_M_M_SUM_M_MANL", "SGY2_SCCYDL_M_M_M_SUM_M_MANL",
			"SGYA_SCCYDL_M_M_M_SUM_M_MANL", "SGYB_SCCYDL_M_M_M_SUM_M_MANL", "MMP5_SCCYDL_M_M_M_SUM_M_MANL",
			"MMP6_SCCYDL_M_M_M_SUM_M_MANL", "MMP7_SCCYDL_M_M_M_SUM_M_MANL", "MXP5_SCCYDL_M_M_M_SUM_M_MANL",
			"MXP6_SCCYDL_M_M_M_SUM_M_MANL", "YFA1_SCCYDL_M_M_M_SUM_M_MANL", "YFA2_SCCYDL_M_M_M_SUM_M_MANL",
			"YFC5_SCCYDL_M_M_M_SUM_M_MANL", "YFC6_SCCYDL_M_M_M_SUM_M_MANL", "YLP1_SCCYDL_M_M_M_SUM_M_MANL",
			"YLP2_SCCYDL_M_M_M_SUM_M_MANL", "JWP3_SCCYDL_M_M_M_SUM_M_MANL", "JWP4_SCCYDL_M_M_M_SUM_M_MANL",
			"HHW1_SCCYDL_M_M_M_SUM_M_MANL", "HHW2_SCCYDL_M_M_M_SUM_M_MANL", "HHW3_SCCYDL_M_M_M_SUM_M_MANL",
			"HHW4_SCCYDL_M_M_M_SUM_M_MANL", "JHP1_SCCYDL_M_M_M_SUM_M_MANL", "JHP2_SCCYDL_M_M_M_SUM_M_MANL",
			"JHP3_SCCYDL_M_M_M_SUM_M_MANL", "JHP4_SCCYDL_M_M_M_SUM_M_MANL", "PHP1_SCCYDL_M_M_M_SUM_M_MANL",
			"PHP2_SCCYDL_M_M_M_SUM_M_MANL", "PNP1_SCCYDL_M_M_M_SUM_M_MANL", "PNP2_SCCYDL_M_M_M_SUM_M_MANL",
			"PNP3_SCCYDL_M_M_M_SUM_M_MANL", "PNP4_SCCYDL_M_M_M_SUM_M_MANL", "TSP1_SCCYDL_M_M_M_SUM_M_MANL",
			"TSP2_SCCYDL_M_M_M_SUM_M_MANL", "DPP1_SCCYDL_M_M_M_SUM_M_MANL", "DPP2_SCCYDL_M_M_M_SUM_M_MANL",
			"HZL1_SCCYDL_M_M_M_SUM_M_MANL", "HZL2_SCCYDL_M_M_M_SUM_M_MANL", "HZL3_SCCYDL_M_M_M_SUM_M_MANL",
			"GQL1_SCCYDL_M_M_M_SUM_M_MANL", "GQL2_SCCYDL_M_M_M_SUM_M_MANL", "GQL3_SCCYDL_M_M_M_SUM_M_MANL",
			"SWF1_SCCYDL_M_M_M_SUM_M_MANL", "SWF2_SCCYDL_M_M_M_SUM_M_MANL", "SBS1_SCCYDL_M_M_M_SUM_M_MANL",
			"ZJW_SCCYDL_M_M_M_SUM_M_MANL", "HLW_SCCYDL_M_M_M_SUM_M_MANL", "DBW_SCCYDL_M_M_M_SUM_M_MANL",
			"PXW_SCCYDL_M_M_M_SUM_M_MANL", "ZYW_SCCYDL_M_M_M_SUM_M_MANL", "SQW_SCCYDL_M_M_M_SUM_M_MANL",
			"KFE_SCCYDL_M_M_M_SUM_M_MANL", "YXX_SCCYDL_M_M_M_SUM_M_MANL" };

	/**
	 * 计算发电煤耗的发电量(万千瓦时)
	 */
	static final String[] FDMHFDL_ALL = new String[] { "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "",
			"", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "",
			"SJA1_SCCYDL_M_M_M_SUM_M_MANL", "SJA2_SCCYDL_M_M_M_SUM_M_MANL", "SJA3_SCCYDL_M_M_M_SUM_M_MANL",
			"SJA4_SCCYDL_M_M_M_SUM_M_MANL", "SJA5_SCCYDL_M_M_M_SUM_M_MANL", "SJC1_SCCYDL_M_M_M_SUM_M_MANL",
			"SJC2_SCCYDL_M_M_M_SUM_M_MANL", "SJC3_SCCYDL_M_M_M_SUM_M_MANL", "ZHP1_SCCYDL_M_M_M_SUM_M_MANL",
			"ZHP2_SCCYDL_M_M_M_SUM_M_MANL", "HPP1_SCCYDL_M_M_M_SUM_M_MANL", "HPP2_SCCYDL_M_M_M_SUM_M_MANL",
			"ZJP1_SCCYDL_M_M_M_SUM_M_MANL", "ZJP2_SCCYDL_M_M_M_SUM_M_MANL", "ZJP3_SCCYDL_M_M_M_SUM_M_MANL",
			"ZJP4_SCCYDL_M_M_M_SUM_M_MANL", "SGY1_SCCYDL_M_M_M_SUM_M_MANL", "SGY2_SCCYDL_M_M_M_SUM_M_MANL",
			"SGYA_SCCYDL_M_M_M_SUM_M_MANL", "SGYB_SCCYDL_M_M_M_SUM_M_MANL", "MMP5_SCCYDL_M_M_M_SUM_M_MANL",
			"MMP6_SCCYDL_M_M_M_SUM_M_MANL", "MMP7_SCCYDL_M_M_M_SUM_M_MANL", "MXP5_SCCYDL_M_M_M_SUM_M_MANL",
			"MXP6_SCCYDL_M_M_M_SUM_M_MANL", "YFA1_SCCYDL_M_M_M_SUM_M_MANL", "YFA2_SCCYDL_M_M_M_SUM_M_MANL",
			"YFC5_SCCYDL_M_M_M_SUM_M_MANL", "YFC6_SCCYDL_M_M_M_SUM_M_MANL", "YLP1_SCCYDL_M_M_M_SUM_M_MANL",
			"YLP2_SCCYDL_M_M_M_SUM_M_MANL", "JWP3_SCCYDL_M_M_M_SUM_M_MANL", "JWP4_SCCYDL_M_M_M_SUM_M_MANL",
			"HHW1_SCCYDL_M_M_M_SUM_M_MANL", "HHW2_SCCYDL_M_M_M_SUM_M_MANL", "HHW3_SCCYDL_M_M_M_SUM_M_MANL",
			"HHW4_SCCYDL_M_M_M_SUM_M_MANL", "JHP1_SCCYDL_M_M_M_SUM_M_MANL", "JHP2_SCCYDL_M_M_M_SUM_M_MANL",
			"JHP3_SCCYDL_M_M_M_SUM_M_MANL", "JHP4_SCCYDL_M_M_M_SUM_M_MANL", "PHP1_SCCYDL_M_M_M_SUM_M_MANL",
			"PHP2_SCCYDL_M_M_M_SUM_M_MANL", "PNP1_SCCYDL_M_M_M_SUM_M_MANL", "PNP2_SCCYDL_M_M_M_SUM_M_MANL",
			"PNP3_SCCYDL_M_M_M_SUM_M_MANL", "PNP4_SCCYDL_M_M_M_SUM_M_MANL", "TSP1_SCCYDL_M_M_M_SUM_M_MANL",
			"TSP2_SCCYDL_M_M_M_SUM_M_MANL", "DPP1_SCCYDL_M_M_M_SUM_M_MANL", "DPP2_SCCYDL_M_M_M_SUM_M_MANL",
			"HZL1_SCCYDL_M_M_M_SUM_M_MANL", "HZL2_SCCYDL_M_M_M_SUM_M_MANL", "HZL3_SCCYDL_M_M_M_SUM_M_MANL",
			"GQL1_SCCYDL_M_M_M_SUM_M_MANL", "GQL2_SCCYDL_M_M_M_SUM_M_MANL", "GQL3_SCCYDL_M_M_M_SUM_M_MANL",
			"SWF1_SCCYDL_M_M_M_SUM_M_MANL", "SWF2_SCCYDL_M_M_M_SUM_M_MANL", "", "", "", "", "", "", "", "", "" };

	/**
	 * 发电消耗标准煤量(吨)
	 */
	static final String[] FDXHBZ_ALL = new String[] { "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "",
			"", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "",
			"SJA1_FDZJZB_M_M_M_SUM_M_MANL", "SJA2_FDZJZB_M_M_M_SUM_M_MANL", "SJA3_FDZJZB_M_M_M_SUM_M_MANL",
			"SJA4_FDZJZB_M_M_M_SUM_M_MANL", "SJA5_FDZJZB_M_M_M_SUM_M_MANL", "SJC1_FDZJZB_M_M_M_SUM_M_MANL",
			"SJC2_FDZJZB_M_M_M_SUM_M_MANL", "SJC3_FDZJZB_M_M_M_SUM_M_MANL", "ZHP1_FDZJZB_M_M_M_SUM_M_MANL",
			"ZHP2_FDZJZB_M_M_M_SUM_M_MANL", "HPP1_FDZJZB_M_M_M_SUM_M_MANL", "HPP2_FDZJZB_M_M_M_SUM_M_MANL",
			"ZJP1_FDZJZB_M_M_M_SUM_M_MANL", "ZJP2_FDZJZB_M_M_M_SUM_M_MANL", "ZJP3_FDZJZB_M_M_M_SUM_M_MANL",
			"ZJP4_FDZJZB_M_M_M_SUM_M_MANL", "SGY1_FDZJZB_M_M_M_SUM_M_MANL", "SGY2_FDZJZB_M_M_M_SUM_M_MANL",
			"SGYA_FDZJZB_M_M_M_SUM_M_MANL", "SGYB_FDZJZB_M_M_M_SUM_M_MANL", "MMP5_FDZJZB_M_M_M_SUM_M_MANL",
			"MMP6_FDZJZB_M_M_M_SUM_M_MANL", "MMP7_FDZJZB_M_M_M_SUM_M_MANL", "MXP5_FDZJZB_M_M_M_SUM_M_MANL",
			"MXP6_FDZJZB_M_M_M_SUM_M_MANL", "YFA1_FDZJZB_M_M_M_SUM_M_MANL", "YFA2_FDZJZB_M_M_M_SUM_M_MANL",
			"YFC5_FDZJZB_M_M_M_SUM_M_MANL", "YFC6_FDZJZB_M_M_M_SUM_M_MANL", "YLP1_FDZJZB_M_M_M_SUM_M_MANL",
			"YLP2_FDZJZB_M_M_M_SUM_M_MANL", "JWP3_FDZJZB_M_M_M_SUM_M_MANL", "JWP4_FDZJZB_M_M_M_SUM_M_MANL",
			"HHW1_FDZJZB_M_M_M_SUM_M_MANL", "HHW2_FDZJZB_M_M_M_SUM_M_MANL", "HHW3_FDZJZB_M_M_M_SUM_M_MANL",
			"HHW4_FDZJZB_M_M_M_SUM_M_MANL", "JHP1_FDZJZB_M_M_M_SUM_M_MANL", "JHP2_FDZJZB_M_M_M_SUM_M_MANL",
			"JHP3_FDZJZB_M_M_M_SUM_M_MANL", "JHP4_FDZJZB_M_M_M_SUM_M_MANL", "PHP1_FDZJZB_M_M_M_SUM_M_MANL",
			"PHP2_FDZJZB_M_M_M_SUM_M_MANL", "PNP1_FDZJZB_M_M_M_SUM_M_MANL", "PNP2_FDZJZB_M_M_M_SUM_M_MANL",
			"PNP3_FDZJZB_M_M_M_SUM_M_MANL", "PNP4_FDZJZB_M_M_M_SUM_M_MANL", "TSP1_FDZJZB_M_M_M_SUM_M_MANL",
			"TSP2_FDZJZB_M_M_M_SUM_M_MANL", "DPP1_FDZJZB_M_M_M_SUM_M_MANL", "DPP2_FDZJZB_M_M_M_SUM_M_MANL",
			"HZL1_FDZJZB_M_M_M_SUM_M_MANL", "HZL2_FDZJZB_M_M_M_SUM_M_MANL", "HZL3_FDZJZB_M_M_M_SUM_M_MANL",
			"GQL1_FDZJZB_M_M_M_SUM_M_MANL", "GQL2_FDZJZB_M_M_M_SUM_M_MANL", "GQL3_FDZJZB_M_M_M_SUM_M_MANL",
			"SWF1_FDZJZB_M_M_M_SUM_M_MANL", "SWF2_FDZJZB_M_M_M_SUM_M_MANL", "", "", "", "", "", "", "", "", "" };

	/**
	 * 发电耗用-原煤(吨)
	 */
	static final String[] FDHY_YM_ALL = new String[] { "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "",
			"", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "",
			"SJA1_HYM_M_M_M_SUM_M_MANL", "SJA2_HYM_M_M_M_SUM_M_MANL", "SJA3_HYM_M_M_M_SUM_M_MANL",
			"SJA4_HYM_M_M_M_SUM_M_MANL", "SJA5_HYM_M_M_M_SUM_M_MANL", "SJC1_HYM_M_M_M_SUM_M_MANL",
			"SJC2_HYM_M_M_M_SUM_M_MANL", "SJC3_HYM_M_M_M_SUM_M_MANL", "ZHP1_HYM_M_M_M_SUM_M_MANL",
			"ZHP2_HYM_M_M_M_SUM_M_MANL", "HPP1_HYM_M_M_M_SUM_M_MANL", "HPP2_HYM_M_M_M_SUM_M_MANL",
			"ZJP1_HYM_M_M_M_SUM_M_MANL", "ZJP2_HYM_M_M_M_SUM_M_MANL", "ZJP3_HYM_M_M_M_SUM_M_MANL",
			"ZJP4_HYM_M_M_M_SUM_M_MANL", "SGY1_HYM_M_M_M_SUM_M_MANL", "SGY2_HYM_M_M_M_SUM_M_MANL",
			"SGYA_HYM_M_M_M_SUM_M_MANL", "SGYB_HYM_M_M_M_SUM_M_MANL", "MMP5_HYM_M_M_M_SUM_M_MANL",
			"MMP6_HYM_M_M_M_SUM_M_MANL", "MMP7_HYM_M_M_M_SUM_M_MANL", "MXP5_HYM_M_M_M_SUM_M_MANL",
			"MXP6_HYM_M_M_M_SUM_M_MANL", "YFA1_HYM_M_M_M_SUM_M_MANL", "YFA2_HYM_M_M_M_SUM_M_MANL",
			"YFC5_HYM_M_M_M_SUM_M_MANL", "YFC6_HYM_M_M_M_SUM_M_MANL", "YLP1_HYM_M_M_M_SUM_M_MANL",
			"YLP2_HYM_M_M_M_SUM_M_MANL", "JWP3_HYM_M_M_M_SUM_M_MANL", "JWP4_HYM_M_M_M_SUM_M_MANL",
			"HHW1_HYM_M_M_M_SUM_M_MANL", "HHW2_HYM_M_M_M_SUM_M_MANL", "HHW3_HYM_M_M_M_SUM_M_MANL",
			"HHW4_HYM_M_M_M_SUM_M_MANL", "JHP1_HYM_M_M_M_SUM_M_MANL", "JHP2_HYM_M_M_M_SUM_M_MANL",
			"JHP3_HYM_M_M_M_SUM_M_MANL", "JHP4_HYM_M_M_M_SUM_M_MANL", "PHP1_HYM_M_M_M_SUM_M_MANL",
			"PHP2_HYM_M_M_M_SUM_M_MANL", "PNP1_HYM_M_M_M_SUM_M_MANL", "PNP2_HYM_M_M_M_SUM_M_MANL",
			"PNP3_HYM_M_M_M_SUM_M_MANL", "PNP4_HYM_M_M_M_SUM_M_MANL", "TSP1_HYM_M_M_M_SUM_M_MANL",
			"TSP2_HYM_M_M_M_SUM_M_MANL", "DPP1_HYM_M_M_M_SUM_M_MANL", "DPP2_HYM_M_M_M_SUM_M_MANL", "", "", "", "", "",
			"", "", "", "", "", "", "", "", "", "", "", "" };

	/**
	 * 发电耗用-燃油(吨)
	 */
	static final String[] FDHY_RY_ALL = new String[] { "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "",
			"", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "",
			"SJA1_HYY_M_M_M_SUM_M_MANL", "SJA2_HYY_M_M_M_SUM_M_MANL", "SJA3_HYY_M_M_M_SUM_M_MANL",
			"SJA4_HYY_M_M_M_SUM_M_MANL", "SJA5_HYY_M_M_M_SUM_M_MANL", "SJC1_HYY_M_M_M_SUM_M_MANL",
			"SJC2_HYY_M_M_M_SUM_M_MANL", "SJC3_HYY_M_M_M_SUM_M_MANL", "ZHP1_HYY_M_M_M_SUM_M_MANL",
			"ZHP2_HYY_M_M_M_SUM_M_MANL", "HPP1_HYY_M_M_M_SUM_M_MANL", "HPP2_HYY_M_M_M_SUM_M_MANL",
			"ZJP1_HYY_M_M_M_SUM_M_MANL", "ZJP2_HYY_M_M_M_SUM_M_MANL", "ZJP3_HYY_M_M_M_SUM_M_MANL",
			"ZJP4_HYY_M_M_M_SUM_M_MANL", "SGY1_HYY_M_M_M_SUM_M_MANL", "SGY2_HYY_M_M_M_SUM_M_MANL",
			"SGYA_HYY_M_M_M_SUM_M_MANL", "SGYB_HYY_M_M_M_SUM_M_MANL", "MMP5_HYY_M_M_M_SUM_M_MANL",
			"MMP6_HYY_M_M_M_SUM_M_MANL", "MMP7_HYY_M_M_M_SUM_M_MANL", "MXP5_HYY_M_M_M_SUM_M_MANL",
			"MXP6_HYY_M_M_M_SUM_M_MANL", "YFA1_HYY_M_M_M_SUM_M_MANL", "YFA2_HYY_M_M_M_SUM_M_MANL",
			"YFC5_HYY_M_M_M_SUM_M_MANL", "YFC6_HYY_M_M_M_SUM_M_MANL", "YLP1_HYY_M_M_M_SUM_M_MANL",
			"YLP2_HYY_M_M_M_SUM_M_MANL", "JWP3_HYY_M_M_M_SUM_M_MANL", "JWP4_HYY_M_M_M_SUM_M_MANL",
			"HHW1_HYY_M_M_M_SUM_M_MANL", "HHW2_HYY_M_M_M_SUM_M_MANL", "HHW3_HYY_M_M_M_SUM_M_MANL",
			"HHW4_HYY_M_M_M_SUM_M_MANL", "JHP1_HYY_M_M_M_SUM_M_MANL", "JHP2_HYY_M_M_M_SUM_M_MANL",
			"JHP3_HYY_M_M_M_SUM_M_MANL", "JHP4_HYY_M_M_M_SUM_M_MANL", "PHP1_HYY_M_M_M_SUM_M_MANL",
			"PHP2_HYY_M_M_M_SUM_M_MANL", "PNP1_HYY_M_M_M_SUM_M_MANL", "PNP2_HYY_M_M_M_SUM_M_MANL",
			"PNP3_HYY_M_M_M_SUM_M_MANL", "PNP4_HYY_M_M_M_SUM_M_MANL", "TSP1_HYY_M_M_M_SUM_M_MANL",
			"TSP2_HYY_M_M_M_SUM_M_MANL", "DPP1_HYY_M_M_M_SUM_M_MANL", "DPP2_HYY_M_M_M_SUM_M_MANL", "", "", "", "", "",
			"", "", "", "", "", "", "", "", "", "", "", "" };

	/**
	 * 发电耗用-天然气(万立方米)
	 */
	static final String[] FDHY_TRQ_ALL = new String[] { "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "",
			"", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "",
			"", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "MMP5_HRQ_M_M_M_SUM_M_MANL",
			"MMP6_HRQ_M_M_M_SUM_M_MANL", "MMP7_HRQ_M_M_M_SUM_M_MANL", "", "", "", "", "", "", "", "", "", "", "", "",
			"", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "HZL1_HRQ_M_M_M_SUM_M_MANL",
			"HZL2_HRQ_M_M_M_SUM_M_MANL", "HZL3_HRQ_M_M_M_SUM_M_MANL", "GQL1_HRQ_M_M_M_SUM_M_MANL",
			"GQL2_HRQ_M_M_M_SUM_M_MANL", "GQL3_HRQ_M_M_M_SUM_M_MANL", "", "", "", "", "", "", "", "", "", "", ""

	};

	/**
	 * 供热量(吉焦)
	 */
	static final String[] GRL_ALL = new String[] { "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "",
			"", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "",
			"", "", "", "", "", "", "", "", "", "", "", "", "", "", "MMP5_GRL_M_M_M_SUM_M_MANL",
			"MMP6_GRL_M_M_M_SUM_M_MANL", "MMP7_GRL_M_M_M_SUM_M_MANL", "", "", "", "", "", "", "", "", "", "", "", "",
			"", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "",
			"", "", "", "", "", ""

	};

	/**
	 * 供热燃料消耗-原煤(吨)
	 */
	static final String[] GRRL_YM_ALL = new String[] { "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "",
			"", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "",
			"", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "MMP5_GRHYM_M_M_M_SUM_M_CTST",
			"MMP6_GRHYM_M_M_M_SUM_M_CTST", "MMP7_GRHYM_M_M_M_SUM_M_CTST", "", "", "", "", "", "", "", "", "", "", "",
			"", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "",
			"", "", "", "", "", "", ""

	};

	/**
	 * 供热燃料消耗-燃油(吨)
	 */
	static final String[] GRRL_RY_ALL = new String[] { "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "",
			"", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "",
			"", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "MMP5_GRHYY_M_M_M_SUM_M_CTST",
			"MMP6_GRHYY_M_M_M_SUM_M_CTST", "MMP7_GRHYY_M_M_M_SUM_M_CTST", "", "", "", "", "", "", "", "", "", "", "",
			"", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "",
			"", "", "", "", "", "", ""

	};

	/**
	 * 供热燃料消耗-天然气(万立方米)
	 */
	static final String[] GRRL_TRQ_ALL = new String[] { "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "",
			"", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "",
			"", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "MMP5_GRHRQ_M_M_M_SUM_M_CTST",
			"MMP6_GRHRQ_M_M_M_SUM_M_CTST", "MMP7_GRHRQ_M_M_M_SUM_M_CTST", "", "", "", "", "", "", "", "", "", "", "",
			"", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "",
			"", "", "", "", "", "", ""

	};

	/**
	 * 供热厂用电-厂用电量(万千瓦时)
	 */
	static final String[] GRCYD_YDL_ALL = new String[] { "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "",
			"", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "",
			"", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "MMP5_GRCYDL_M_M_M_SUM_M_MANL",
			"MMP6_GRCYDL_M_M_M_SUM_M_MANL", "MMP7_GRCYDL_M_M_M_SUM_M_MANL", "", "", "", "", "", "", "", "", "", "", "",
			"", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "",
			"", "", "", "", "", "", ""

	};

	/**
	 * 供热标准煤量(吨)
	 */
	static final String[] GRBZML_ALL = new String[] { "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "",
			"", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "",
			"", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "MMP5_GRZJZB_M_M_M_SUM_M_CTST",
			"MMP6_GRZJZB_M_M_M_SUM_M_CTST", "MMP7_GRZJZB_M_M_M_SUM_M_CTST", "", "", "", "", "", "", "", "", "", "", "",
			"", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "",
			"", "", "", "", "", "", ""

	};

	/**
	 * 报表左上角信息设置
	 */
	private static final String[] REPORT_DESC = new String[] { "CEC106-6000千瓦及以上电厂发电机组运行情况（年报）", "424996" };

	/**
	 * 更新IndicatorMapperReport3数据
	 */
	@Transactional
	public Boolean updateDatas(Long time) {
		Date date = new Date(time);
		Calendar cal = Calendar.getInstance();
		cal.setTime(date);
		// 设置用户选择的月份的当月为结束时间
		long endTime = time;
		// 查询IndicatorMapperReport2表中当前时间戳是否存在数据
		List<IndicatorMapperReport2> historyReports = reportRepository.findByTimeOrderByRowIndexAsc(endTime);
		List<IndicatorMapperReport2> reportData = null;
		// 如果存在数据,则需要保留之前页面手动录入的数据。
		if (historyReports.size() != 0) {
			reportData = setUpdateReportData(historyReports, endTime);
		} else {// 如果不存在数据，则直接更新数据
			reportData = new ArrayList<>();
			for (int i = 0; i < ALL_ROW_NAME.length; i++) {
				IndicatorMapperReport2 report = new IndicatorMapperReport2();
				// 设置时间
				report.setTime(endTime);
				// 设置行号
				report.setRowIndex(i + 1);
				String[] rowName = ALL_ROW_NAME[i].split("##");
				// 设置电厂名称及机组编号
				report.setDcmcjjzbm(rowName[0]);
				// 设置指标代码
				report.setZbdm(rowName[1]);
				// 设置组织机构代码
				if (rowName[2].equals("null")) {
					report.setZzjgdm("");
				} else {
					report.setZzjgdm(rowName[2]);
				}
				report.setQmfdsbrl(0.0);
				report.setGrsbrl(0.0);
				report.setFdl_hj(0.0);
				report.setFdl_syx(0.0);
				report.setPjlyxs(0.0);
				report.setPjsbrl(0.0);
				report.setJscydldfdl(0.0);
				report.setFdcydl(0.0);
				report.setFdcydlv(0.0);
				report.setJsfdmhdfdl(0.0);
				report.setJsgdmhdgdl(0.0);
				report.setFdxhbzml(0.0);
				report.setBzmh_fd(0.0);
				report.setBzmh_gd(0.0);
				report.setFdhyym(0.0);
				report.setFdhyry(0.0);
				report.setFdhytrq(0.0);
				report.setGrl(0.0);
				report.setGrrlxh_ym(0.0);
				report.setGrrlxh_ry(0.0);
				report.setGrrlxh_trq(0.0);
				report.setGrcyd_cydl(0.0);
				report.setGrcyd_cdylv(0.0);
				report.setGrbzml(0.0);
				report.setGrbzmh(0.0);
				reportData.add(report);
			}
			reportData = setUpdateReportData(reportData, endTime);
		}
		List<IndicatorMapperReport2> save = reportRepository.save(reportData);
		return save.size() > 0 ? true : false;
	}

	/**
	 * 从MapperData更新的数据，保存之前手动录入的数据。
	 * 
	 * @param historyReports
	 * @param beginTime
	 * @param endTime
	 * @param oldTime
	 * @return
	 */
	private List<IndicatorMapperReport2> setUpdateReportData(List<IndicatorMapperReport2> historyReports,
			Long endTime) {
		IndicatorMapperData findOne = null;
		for (int i = 0; i < 106; i++) {
			// 期末发电设备容量(千瓦)
			if (!QMFDSB_ALL[i].equals("")) {
				findOne = findMapperDatas(QMFDSB_ALL[i], endTime, endTime);
				if (findOne != null) {
					historyReports.get(i).setQmfdsbrl(findOne.getValue());
				}
			}
			// 其中：供热设备容量(千瓦)
			if (!GRSB_ALL[i].equals("")) {
				findOne = findMapperDatas(GRSB_ALL[i], endTime, endTime);
				if (findOne != null) {
					historyReports.get(i).setGrsbrl(findOne.getValue());
				}
			}
			// 发电量(万千瓦时)-合计
			if (!FDL_ALL[i].equals("")) {
				findOne = findMapperDatas(FDL_ALL[i], endTime, endTime);
				if (findOne != null) {
					historyReports.get(i).setFdl_hj(findOne.getValue());
				}
			}
			// 平均设备容量(千瓦)
			if (!PJSB_ALL[i].equals("")) {
				findOne = findMapperDatas(PJSB_ALL[i], endTime, endTime);
				if (findOne != null) {
					historyReports.get(i).setPjsbrl(findOne.getValue());
				}
			}
			// 平均利用小时(小时)
			if (historyReports.get(i).getPjsbrl() != 0.0) {
				historyReports.get(i).setPjlyxs(historyReports.get(i).getFdl_hj() / historyReports.get(i).getPjsbrl());
			}
			// 计算厂用电率的发电量(万千瓦时)
			if (historyReports.get(i).getFdl_hj() - historyReports.get(i).getFdl_syx() >= 0) {
				historyReports.get(i)
						.setJscydldfdl(historyReports.get(i).getFdl_hj() - historyReports.get(i).getFdl_syx());
			}
			// 发电厂用电量(万千瓦时)
			if (!FDCYD_ALL[i].equals("")) {
				findOne = findMapperDatas(FDCYD_ALL[i], endTime, endTime);
				if (findOne != null) {
					historyReports.get(i).setFdcydl(findOne.getValue());
				}
			} else {
				historyReports.get(i).setFdcydl(0.0);
			}
			// 发电厂用电率(%)
			if (historyReports.get(i).getFdcydl() != 0.0) {
				historyReports.get(i)
						.setFdcydlv(historyReports.get(i).getFdcydl() / historyReports.get(i).getJscydldfdl() * 100);
			}
			// 计算发电煤耗的发电量(万千瓦时)
			if (!FDMHFDL_ALL[i].equals("")) {
				findOne = findMapperDatas(FDMHFDL_ALL[i], endTime, endTime);
				if (findOne != null) {
					historyReports.get(i).setJsfdmhdfdl(findOne.getValue());
				}
			}
			// 计算供电煤耗的供电量(万千瓦时)
			if (historyReports.get(i).getFdl_hj() - historyReports.get(i).getFdcydl() >= 0) {
				historyReports.get(i)
						.setJsgdmhdgdl(historyReports.get(i).getFdl_hj() - historyReports.get(i).getFdcydl());
			}
			// 发电消耗标准煤量(吨)
			if (!FDXHBZ_ALL[i].equals("")) {
				findOne = findMapperDatas(FDXHBZ_ALL[i], endTime, endTime);
				if (findOne != null) {
					historyReports.get(i).setFdxhbzml(findOne.getValue());
				}
			}
			// 标准煤耗(克/千瓦时)-发电
			if (historyReports.get(i).getFdl_hj() != 0.0) {
				historyReports.get(i).setBzmh_fd((historyReports.get(i).getFdxhbzml() * 1000 * 1000)
						/ (historyReports.get(i).getFdl_hj() * 10000));
			}
			// 标准煤耗(克/千瓦时)-供电
			if (historyReports.get(i).getJsgdmhdgdl() != 0.0) {
				historyReports.get(i).setBzmh_gd((historyReports.get(i).getFdxhbzml() * 1000 * 1000)
						/ (historyReports.get(i).getJsgdmhdgdl() * 10000));
			}
			// 发电耗用-原煤(吨)
			if (!FDHY_YM_ALL[i].equals("")) {
				findOne = findMapperDatas(FDHY_YM_ALL[i], endTime, endTime);
				if (findOne != null) {
					historyReports.get(i).setFdhyym(findOne.getValue());
				}
			}
			// 发电耗用-燃油(吨)
			if (!FDHY_RY_ALL[i].equals("")) {
				findOne = findMapperDatas(FDHY_RY_ALL[i], endTime, endTime);
				if (findOne != null) {
					historyReports.get(i).setFdhyry(findOne.getValue());
				}
			}
			// 发电耗用-燃油(吨)
			if (!FDHY_TRQ_ALL[i].equals("")) {
				findOne = findMapperDatas(FDHY_TRQ_ALL[i], endTime, endTime);
				if (findOne != null) {
					historyReports.get(i).setFdhytrq(findOne.getValue());
				}
			}
			// 供热量(吉焦)
			if (!GRL_ALL[i].equals("")) {
				findOne = findMapperDatas(GRL_ALL[i], endTime, endTime);
				if (findOne != null) {
					historyReports.get(i).setGrl(findOne.getValue());
				}
			}
			// 供热燃料消耗-原煤(吨)
			if (!GRRL_YM_ALL[i].equals("")) {
				findOne = findMapperDatas(GRRL_YM_ALL[i], endTime, endTime);
				if (findOne != null) {
					historyReports.get(i).setGrrlxh_ym(findOne.getValue());
				}
			}
			// 供热燃料消耗-燃油(吨)
			if (!GRRL_RY_ALL[i].equals("")) {
				findOne = findMapperDatas(GRRL_RY_ALL[i], endTime, endTime);
				if (findOne != null) {
					historyReports.get(i).setGrrlxh_ry(findOne.getValue());
				}
			}
			// 供热燃料消耗-天然气(万立方米)
			if (!GRRL_TRQ_ALL[i].equals("")) {
				findOne = findMapperDatas(GRRL_TRQ_ALL[i], endTime, endTime);
				if (findOne != null) {
					historyReports.get(i).setGrrlxh_trq(findOne.getValue());
				}
			}
			// 供热厂用电-厂用电量(万千瓦时)
			if (!GRCYD_YDL_ALL[i].equals("")) {
				findOne = findMapperDatas(GRCYD_YDL_ALL[i], endTime, endTime);
				if (findOne != null) {
					historyReports.get(i).setGrcyd_cydl(findOne.getValue());
				}
			}
			// 供热厂用电-厂用电率(千瓦时/吉焦)
			if (historyReports.get(i).getGrl() != 0.0) {
				historyReports.get(i).setGrcyd_cdylv(
						(historyReports.get(i).getGrcyd_cydl() * 10000) / historyReports.get(i).getGrl());
			}
			// 供热标准煤量(吨)
			if (!GRBZML_ALL[i].equals("")) {
				findOne = findMapperDatas(GRBZML_ALL[i], endTime, endTime);
				if (findOne != null) {
					historyReports.get(i).setGrbzml(findOne.getValue());
				}
			}
			// 供热标准煤耗(千克/吉焦)
			if (historyReports.get(i).getGrl() != 0.0) {
				historyReports.get(i)
						.setGrbzmh((historyReports.get(i).getGrbzml() * 1000) / historyReports.get(i).getGrl());
			}
		}
		return historyReports;
	}

	/**
	 * 设置MapperDataList查询方法
	 */
	private IndicatorMapperData findMapperDatas(String indicatorCodes, Long beginTime, Long endTime) {
		List<SearchFilter> searchFilters = new ArrayList<>();
		searchFilters.add(SearchFilter.equal("indicatorCode", indicatorCodes));
		searchFilters.add(SearchFilter.ge("time", beginTime));
		searchFilters.add(SearchFilter.le("time", endTime));
		Specification<IndicatorMapperData> buildAndSpec = JpaSearchUtils.buildAndSpec(searchFilters);
		IndicatorMapperData findAll = mapperDataService.findOne(buildAndSpec);
		return findAll;
	}

	/**
	 * 导出报表
	 */
	public HSSFWorkbook exportReport(List<IndicatorMapperReport2> reportDataList) {
		// 创建工作簿
		HSSFWorkbook workBook = new HSSFWorkbook();
		// 创建工作表 工作表的名字叫helloWorld
		HSSFSheet sheet = workBook.createSheet("工作表1");
		// 创建左上角固定报表描述表格
		sheet = creatRepotDesc(workBook, sheet, reportDataList.get(0).getTime());

		// 创建下方主报表
		sheet = creatMainRepot(workBook, sheet, reportDataList);
		return workBook;
	}

	/**
	 * 创建左上角报表
	 * 
	 * @param sheet
	 * @param time
	 * @return
	 */
	public HSSFSheet creatRepotDesc(HSSFWorkbook workBook, HSSFSheet sheet, Long time) {
		// 设置字体样式
		HSSFFont font = workBook.createFont();
		font.setColor(HSSFFont.COLOR_RED);

		// 创建第1行
		HSSFRow row_1 = sheet.createRow(0);
		HSSFCell row_1_cell_1 = row_1.createCell(0);
		row_1_cell_1.setCellValue("*");
		HSSFCell row_1_cell_2 = row_1.createCell(1);
		row_1_cell_2.setCellValue("");
		HSSFCell row_1_cell_3 = row_1.createCell(2);
		row_1_cell_3.setCellValue("1.本表头供系统识别使用；\r\n" + "2.各单位根据具体情况填写单位代码、单位名称、填报人；\r\n" + "3.本表头报告期必须与此报表报告期一致；\r\n"
				+ "4.指标代码必须按照规律编；\r\n" + "5.不可改动报表格式。");
		// 创建第2行
		HSSFRow row_2 = sheet.createRow(1);
		HSSFCell row_2_cell_1 = row_2.createCell(0);
		HSSFRichTextString richString = new HSSFRichTextString("广东粤电集团有限公司");
		richString.applyFont(font);
		row_2_cell_1.setCellValue(richString);
		HSSFCell row_2_cell_2 = row_2.createCell(1);
		row_2_cell_2.setCellValue("（单位名称）");

		// 创建第3行
		HSSFRow row_3 = sheet.createRow(2);
		HSSFCell row_3_cell_1 = row_3.createCell(0);
		richString = new HSSFRichTextString("9808000001");
		richString.applyFont(font);
		row_3_cell_1.setCellValue(richString);
		HSSFCell row_3_cell_2 = row_3.createCell(1);
		row_3_cell_2.setCellValue("（单位代码）");

		// 创建第4行
		HSSFRow row_4 = sheet.createRow(3);
		HSSFCell row_4_cell_1 = row_4.createCell(0);
		richString = new HSSFRichTextString("统计专责");
		richString.applyFont(font);
		row_4_cell_1.setCellValue(richString);
		HSSFCell row_4_cell_2 = row_4.createCell(1);
		row_4_cell_2.setCellValue("（填报人）");

		// 创建第5行
		HSSFRow row_5 = sheet.createRow(4);
		HSSFCell row_5_cell_1 = row_5.createCell(0);
		row_5_cell_1.setCellValue(REPORT_DESC[0]);
		HSSFCell row_5_cell_2 = row_5.createCell(1);
		row_5_cell_2.setCellValue("（表名）");

		// 创建第6行
		HSSFRow row_6 = sheet.createRow(5);
		HSSFCell row_6_cell_1 = row_6.createCell(0);
		row_6_cell_1.setCellValue(REPORT_DESC[1]);
		HSSFCell row_6_cell_2 = row_6.createCell(1);
		row_6_cell_2.setCellValue("（表号）");

		// 创建第7行
		HSSFRow row_7 = sheet.createRow(6);
		HSSFCell row_7_cell_1 = row_7.createCell(0);
		row_7_cell_1.setCellValue("1");
		HSSFCell row_7_cell_2 = row_7.createCell(1);
		row_7_cell_2.setCellValue("（期别）");

		// 创建第8行
		Calendar cal = Calendar.getInstance();
		Date date = new Date(time);
		cal.setTime(date);
		HSSFRow row_8 = sheet.createRow(7);
		HSSFCell row_8_cell_1 = row_8.createCell(0);
		row_8_cell_1.setCellValue(new HSSFRichTextString(String.valueOf(cal.get(Calendar.YEAR))));
		HSSFCell row_8_cell_2 = row_8.createCell(1);
		row_8_cell_2.setCellValue("年");
		HSSFCell row_8_cell_3 = row_8.createCell(2);
		row_8_cell_3.setCellValue(new HSSFRichTextString(String.valueOf(cal.get(Calendar.MONTH) + 1)));
		HSSFCell row_8_cell_4 = row_8.createCell(3);
		row_8_cell_4.setCellValue("月");
		HSSFCell row_8_cell_5 = row_8.createCell(4);
		row_8_cell_5.setCellValue("");

		sheet.addMergedRegion(new CellRangeAddress(0, 6, 2, 2));

		return sheet;
	}

	/**
	 * 创建下方主要表格
	 * 
	 * @param sheet
	 * @param reportDataList
	 * @return
	 */
	@SuppressWarnings("deprecation")
	public HSSFSheet creatMainRepot(HSSFWorkbook workBook, HSSFSheet sheet,
			List<IndicatorMapperReport2> reportDataList) {
		// 创建红色居中样式
		HSSFCellStyle cellStyle = workBook.createCellStyle();
		// 设置居中样式
		cellStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER);
		cellStyle.setAlignment(HSSFCellStyle.VERTICAL_CENTER);
		// 设置字体样式
		HSSFFont font = workBook.createFont();
		font.setColor(HSSFFont.COLOR_RED);
		cellStyle.setFont(font);

		// 创建第9行
		HSSFRow row_9 = sheet.createRow(8);
		HSSFCell row_9_cell_1 = row_9.createCell(0);
		row_9_cell_1.setCellValue("6000千瓦及以上电厂发电机组运行情况");

		// 创建第10行
		HSSFRow row_10 = sheet.createRow(9);
		HSSFCell row_10_cell_1 = row_10.createCell(0);
		row_10_cell_1.setCellValue("综合填报单位：  （章）");
		HSSFCell row_10_cell_2 = row_10.createCell(1);
		row_10_cell_2.setCellValue("");
		HSSFCell row_10_cell_3 = row_10.createCell(2);
		row_10_cell_3.setCellValue("");
		HSSFCell row_10_cell_4 = row_10.createCell(3);
		row_10_cell_4.setCellValue("");
		HSSFCell row_10_cell_5 = row_10.createCell(4);
		row_10_cell_5.setCellValue("");
		HSSFCell row_10_cell_6 = row_10.createCell(5);
		row_10_cell_6.setCellValue("");
		HSSFCell row_10_cell_7 = row_10.createCell(6);
		row_10_cell_7.setCellValue("");
		HSSFCell row_10_cell_8 = row_10.createCell(7);
		row_10_cell_8.setCellValue("");
		HSSFCell row_10_cell_9 = row_10.createCell(8);
		row_10_cell_9.setCellValue("");
		HSSFCell row_10_cell_10 = row_10.createCell(9);
		row_10_cell_10.setCellValue("");
		HSSFCell row_10_cell_11 = row_10.createCell(10);
		row_10_cell_11.setCellValue("");
		HSSFCell row_10_cell_12 = row_10.createCell(11);
		row_10_cell_12.setCellValue("");
		HSSFCell row_10_cell_13 = row_10.createCell(12);
		row_10_cell_13.setCellValue("");
		HSSFCell row_10_cell_14 = row_10.createCell(13);
		row_10_cell_14.setCellValue("");
		HSSFCell row_10_cell_15 = row_10.createCell(14);
		row_10_cell_15.setCellValue("YYYY");
		HSSFCell row_10_cell_16 = row_10.createCell(15);
		row_10_cell_16.setCellValue("");
		HSSFCell row_10_cell_17 = row_10.createCell(16);
		row_10_cell_17.setCellValue("");
		HSSFCell row_10_cell_18 = row_10.createCell(17);
		row_10_cell_18.setCellValue("");
		HSSFCell row_10_cell_19 = row_10.createCell(18);
		row_10_cell_19.setCellValue("");
		HSSFCell row_10_cell_20 = row_10.createCell(19);
		row_10_cell_20.setCellValue("");
		HSSFCell row_10_cell_21 = row_10.createCell(20);
		row_10_cell_21.setCellValue("");
		HSSFCell row_10_cell_22 = row_10.createCell(21);
		row_10_cell_22.setCellValue("");
		HSSFCell row_10_cell_23 = row_10.createCell(22);
		row_10_cell_23.setCellValue("");
		HSSFCell row_10_cell_24 = row_10.createCell(23);
		row_10_cell_24.setCellValue("");
		HSSFCell row_10_cell_25 = row_10.createCell(24);
		row_10_cell_25.setCellValue("");
		HSSFCell row_10_cell_26 = row_10.createCell(25);
		row_10_cell_26.setCellValue("");
		HSSFCell row_10_cell_27 = row_10.createCell(26);
		row_10_cell_27.setCellValue("");
		HSSFCell row_10_cell_28 = row_10.createCell(27);
		row_10_cell_28.setCellValue("");
		HSSFCell row_10_cell_29 = row_10.createCell(28);
		row_10_cell_29.setCellValue("");

		// 创建第11行
		HSSFRow row_11 = sheet.createRow(10);
		HSSFCell row_11_cell_1 = row_11.createCell(0);
		row_11_cell_1.setCellValue("电厂名称及机组编号");
		HSSFCell row_11_cell_2 = row_11.createCell(1);
		row_11_cell_2.setCellValue("指标代码");
		HSSFCell row_11_cell_3 = row_11.createCell(2);
		row_11_cell_3.setCellValue("组织机构代码");
		HSSFCell row_11_cell_4 = row_11.createCell(3);
		row_11_cell_4.setCellValue("期末发电设备容量(千瓦)");
		HSSFCell row_11_cell_5 = row_11.createCell(4);
		row_11_cell_5.setCellValue("其中：供热设备容量(千瓦)");
		HSSFCell row_11_cell_6 = row_11.createCell(5);
		row_11_cell_6.setCellValue("发电量(万千瓦时)");
		HSSFCell row_11_cell_8 = row_11.createCell(7);
		row_11_cell_8.setCellValue("平均利用小时(小时)");
		HSSFCell row_11_cell_9 = row_11.createCell(8);
		row_11_cell_9.setCellValue("平均设备容量(千瓦)");
		HSSFCell row_11_cell_10 = row_11.createCell(9);
		row_11_cell_10.setCellValue("计算厂用电率的发电量(万千瓦时)");
		HSSFCell row_11_cell_11 = row_11.createCell(10);
		row_11_cell_11.setCellValue("发电厂用电量(万千瓦时)");
		HSSFCell row_11_cell_12 = row_11.createCell(11);
		row_11_cell_12.setCellValue("发电厂用电率(%)");
		HSSFCell row_11_cell_13 = row_11.createCell(12);
		row_11_cell_13.setCellValue("计算发电煤耗的发电量(万千瓦时)");
		HSSFCell row_11_cell_14 = row_11.createCell(13);
		row_11_cell_14.setCellValue("计算供电煤耗的供电量(万千瓦时)");
		HSSFCell row_11_cell_15 = row_11.createCell(14);
		row_11_cell_15.setCellValue("发电消耗标准煤量(吨)");
		HSSFCell row_11_cell_16 = row_11.createCell(15);
		row_11_cell_16.setCellValue("标准煤耗(克/千瓦时)");
		HSSFCell row_11_cell_18 = row_11.createCell(17);
		row_11_cell_18.setCellValue("发电耗用原煤、燃油和燃气量等");
		HSSFCell row_11_cell_21 = row_11.createCell(20);
		row_11_cell_21.setCellValue("供热量(吉焦)");
		HSSFCell row_11_cell_22 = row_11.createCell(21);
		row_11_cell_22.setCellValue("供热燃料消耗");
		HSSFCell row_11_cell_25 = row_11.createCell(24);
		row_11_cell_25.setCellValue("供热厂用电");
		HSSFCell row_11_cell_27 = row_11.createCell(26);
		row_11_cell_27.setCellValue("供热标准煤量(吨)");
		HSSFCell row_11_cell_28 = row_11.createCell(27);
		row_11_cell_28.setCellValue("供热标准煤耗(千克/吉焦)");

		// 创建第12行
		HSSFRow row_12 = sheet.createRow(11);
		HSSFCell row_12_cell_6 = row_12.createCell(5);
		row_12_cell_6.setCellValue("合计");
		HSSFCell row_12_cell_7 = row_12.createCell(6);
		row_12_cell_7.setCellValue("试运行");
		HSSFCell row_12_cell_16 = row_12.createCell(15);
		row_12_cell_16.setCellValue("发电");
		HSSFCell row_12_cell_17 = row_12.createCell(16);
		row_12_cell_17.setCellValue("供电");
		HSSFCell row_12_cell_18 = row_12.createCell(17);
		row_12_cell_18.setCellValue("原煤(吨)");
		HSSFCell row_12_cell_19 = row_12.createCell(18);
		row_12_cell_19.setCellValue("燃油(吨)");
		HSSFCell row_12_cell_20 = row_12.createCell(19);
		row_12_cell_20.setCellValue("天然气(万立方米)");
		HSSFCell row_12_cell_22 = row_12.createCell(21);
		row_12_cell_22.setCellValue("原煤(吨)");
		HSSFCell row_12_cell_23 = row_12.createCell(22);
		row_12_cell_23.setCellValue("燃油(吨)");
		HSSFCell row_12_cell_24 = row_12.createCell(23);
		row_12_cell_24.setCellValue("天然气(万立方米)");
		HSSFCell row_12_cell_25 = row_12.createCell(24);
		row_12_cell_25.setCellValue("厂用电量(万千瓦时)");
		HSSFCell row_12_cell_26 = row_12.createCell(25);
		row_12_cell_26.setCellValue("厂用电率(千瓦时/吉焦)");

		// 创建第13行
		HSSFRow row_13 = sheet.createRow(12);
		HSSFCell row_13_cell_1 = row_13.createCell(0);
		row_13_cell_1.setCellValue("甲");
		HSSFCell row_13_cell_2 = row_13.createCell(1);
		row_13_cell_2.setCellValue("1");
		HSSFCell row_13_cell_3 = row_13.createCell(2);
		row_13_cell_3.setCellValue("2");
		HSSFCell row_13_cell_4 = row_13.createCell(3);
		row_13_cell_4.setCellValue("3");
		HSSFCell row_13_cell_5 = row_13.createCell(4);
		row_13_cell_5.setCellValue("4");
		HSSFCell row_13_cell_6 = row_13.createCell(5);
		row_13_cell_6.setCellValue("5");
		HSSFCell row_13_cell_7 = row_13.createCell(6);
		row_13_cell_7.setCellValue("6");
		HSSFCell row_13_cell_8 = row_13.createCell(7);
		row_13_cell_8.setCellValue("7");
		HSSFCell row_13_cell_9 = row_13.createCell(8);
		row_13_cell_9.setCellValue("8");
		HSSFCell row_13_cell_10 = row_13.createCell(9);
		row_13_cell_10.setCellValue("9");
		HSSFCell row_13_cell_11 = row_13.createCell(10);
		row_13_cell_11.setCellValue("10");
		HSSFCell row_13_cell_12 = row_13.createCell(11);
		row_13_cell_12.setCellValue("11");
		HSSFCell row_13_cell_13 = row_13.createCell(12);
		row_13_cell_13.setCellValue("12");
		HSSFCell row_13_cell_14 = row_13.createCell(13);
		row_13_cell_14.setCellValue("13");
		HSSFCell row_13_cell_15 = row_13.createCell(14);
		row_13_cell_15.setCellValue("14");
		HSSFCell row_13_cell_16 = row_13.createCell(15);
		row_13_cell_16.setCellValue("15");
		HSSFCell row_13_cell_17 = row_13.createCell(16);
		row_13_cell_17.setCellValue("16");
		HSSFCell row_13_cell_18 = row_13.createCell(17);
		row_13_cell_18.setCellValue("17");
		HSSFCell row_13_cell_19 = row_13.createCell(18);
		row_13_cell_19.setCellValue("18");
		HSSFCell row_13_cell_20 = row_13.createCell(19);
		row_13_cell_20.setCellValue("19");
		HSSFCell row_13_cell_21 = row_13.createCell(20);
		row_13_cell_21.setCellValue("20");
		HSSFCell row_13_cell_22 = row_13.createCell(21);
		row_13_cell_22.setCellValue("21");
		HSSFCell row_13_cell_23 = row_13.createCell(22);
		row_13_cell_23.setCellValue("22");
		HSSFCell row_13_cell_24 = row_13.createCell(23);
		row_13_cell_24.setCellValue("23");
		HSSFCell row_13_cell_25 = row_13.createCell(24);
		row_13_cell_25.setCellValue("24");
		HSSFCell row_13_cell_26 = row_13.createCell(25);
		row_13_cell_26.setCellValue("25");
		HSSFCell row_13_cell_27 = row_13.createCell(26);
		row_13_cell_27.setCellValue("26");
		HSSFCell row_13_cell_28 = row_13.createCell(27);
		row_13_cell_28.setCellValue("27");

		// 创建第14行
		HSSFRow row_14 = sheet.createRow(13);
		HSSFCell row_14_cell_1 = row_14.createCell(0);
		row_14_cell_1.setCellValue("机组明细");
		HSSFCell row_14_cell_2 = row_14.createCell(1);
		row_14_cell_2.setCellValue("01");
		HSSFCell row_14_cell_3 = row_14.createCell(2);
		row_14_cell_3.setCellValue("");
		HSSFCell row_14_cell_4 = row_14.createCell(3);
		row_14_cell_4.setCellValue("");
		HSSFCell row_14_cell_5 = row_14.createCell(4);
		row_14_cell_5.setCellValue("");
		HSSFCell row_14_cell_6 = row_14.createCell(5);
		row_14_cell_6.setCellValue("");
		HSSFCell row_14_cell_7 = row_14.createCell(6);
		row_14_cell_7.setCellValue("");
		HSSFCell row_14_cell_8 = row_14.createCell(7);
		row_14_cell_8.setCellValue("");
		HSSFCell row_14_cell_9 = row_14.createCell(8);
		row_14_cell_9.setCellValue("");
		HSSFCell row_14_cell_10 = row_14.createCell(9);
		row_14_cell_10.setCellValue("");
		HSSFCell row_14_cell_11 = row_14.createCell(10);
		row_14_cell_11.setCellValue("");
		HSSFCell row_14_cell_12 = row_14.createCell(11);
		row_14_cell_12.setCellValue("");
		HSSFCell row_14_cell_13 = row_14.createCell(12);
		row_14_cell_13.setCellValue("");
		HSSFCell row_14_cell_14 = row_14.createCell(13);
		row_14_cell_14.setCellValue("");
		HSSFCell row_14_cell_15 = row_14.createCell(14);
		row_14_cell_15.setCellValue("");
		HSSFCell row_14_cell_16 = row_14.createCell(15);
		row_14_cell_16.setCellValue("");
		HSSFCell row_14_cell_17 = row_14.createCell(16);
		row_14_cell_17.setCellValue("");
		HSSFCell row_14_cell_18 = row_14.createCell(17);
		row_14_cell_18.setCellValue("");
		HSSFCell row_14_cell_19 = row_14.createCell(18);
		row_14_cell_19.setCellValue("");
		HSSFCell row_14_cell_20 = row_14.createCell(19);
		row_14_cell_20.setCellValue("");
		HSSFCell row_14_cell_21 = row_14.createCell(20);
		row_14_cell_21.setCellValue("");
		HSSFCell row_14_cell_22 = row_14.createCell(21);
		row_14_cell_22.setCellValue("");
		HSSFCell row_14_cell_23 = row_14.createCell(22);
		row_14_cell_23.setCellValue("");
		HSSFCell row_14_cell_24 = row_14.createCell(23);
		row_14_cell_24.setCellValue("");
		HSSFCell row_14_cell_25 = row_14.createCell(24);
		row_14_cell_25.setCellValue("");
		HSSFCell row_14_cell_26 = row_14.createCell(25);
		row_14_cell_26.setCellValue("");
		HSSFCell row_14_cell_27 = row_14.createCell(26);
		row_14_cell_27.setCellValue("");
		HSSFCell row_14_cell_28 = row_14.createCell(27);
		row_14_cell_28.setCellValue("");

		for (IndicatorMapperReport2 report : reportDataList) {
			HSSFRow row = sheet.createRow(report.getRowIndex() + ROW_INDEX);
			HSSFCell row_cell_1 = row.createCell(0);
			row_cell_1.setCellValue(report.getDcmcjjzbm());
			HSSFCell row_cell_2 = row.createCell(1);
			row_cell_2.setCellValue(report.getZbdm());
			HSSFCell row_cell_3 = row.createCell(2);
			row_cell_3.setCellValue(report.getZzjgdm());
			HSSFCell row_cell_4 = row.createCell(3);
			row_cell_4.setCellValue(report.getQmfdsbrl());
			HSSFCell row_cell_5 = row.createCell(4);
			row_cell_5.setCellValue(report.getGrsbrl());
			HSSFCell row_cell_6 = row.createCell(5);
			row_cell_6.setCellValue(report.getFdl_hj());
			HSSFCell row_cell_7 = row.createCell(6);
			row_cell_7.setCellValue(report.getFdl_syx());
			HSSFCell row_cell_8 = row.createCell(7);
			row_cell_8.setCellValue(report.getPjlyxs());
			HSSFCell row_cell_9 = row.createCell(8);
			row_cell_9.setCellValue(report.getPjsbrl());
			HSSFCell row_cell_10 = row.createCell(9);
			row_cell_10.setCellValue(report.getJscydldfdl());
			HSSFCell row_cell_11 = row.createCell(10);
			row_cell_11.setCellValue(report.getFdcydl());
			HSSFCell row_cell_12 = row.createCell(11);
			row_cell_12.setCellValue(report.getFdcydlv());
			HSSFCell row_cell_13 = row.createCell(12);
			row_cell_13.setCellValue(report.getJsfdmhdfdl());
			HSSFCell row_cell_14 = row.createCell(13);
			row_cell_14.setCellValue(report.getJsfdmhdfdl());
			HSSFCell row_cell_15 = row.createCell(14);
			row_cell_15.setCellValue(report.getFdxhbzml());
			HSSFCell row_cell_16 = row.createCell(15);
			row_cell_16.setCellValue(report.getBzmh_fd());
			HSSFCell row_cell_17 = row.createCell(16);
			row_cell_17.setCellValue(report.getBzmh_gd());
			HSSFCell row_cell_18 = row.createCell(17);
			row_cell_18.setCellValue(report.getFdhyym());
			HSSFCell row_cell_19 = row.createCell(18);
			row_cell_19.setCellValue(report.getFdhyry());
			HSSFCell row_cell_20 = row.createCell(19);
			row_cell_20.setCellValue(report.getFdhytrq());
			HSSFCell row_cell_21 = row.createCell(20);
			row_cell_21.setCellValue(report.getGrl());
			HSSFCell row_cell_22 = row.createCell(21);
			row_cell_22.setCellValue(report.getGrrlxh_ym());
			HSSFCell row_cell_23 = row.createCell(22);
			row_cell_23.setCellValue(report.getGrrlxh_ry());
			HSSFCell row_cell_24 = row.createCell(23);
			row_cell_24.setCellValue(report.getGrrlxh_trq());
			HSSFCell row_cell_25 = row.createCell(24);
			row_cell_25.setCellValue(report.getGrcyd_cydl());
			HSSFCell row_cell_26 = row.createCell(25);
			row_cell_26.setCellValue(report.getGrcyd_cdylv());
			HSSFCell row_cell_27 = row.createCell(26);
			row_cell_27.setCellValue(report.getGrbzml());
			HSSFCell row_cell_28 = row.createCell(27);
			row_cell_28.setCellValue(report.getGrbzmh());
		}

		// 合并6000千瓦及以上电厂发电机组运行情况单元格
		sheet.addMergedRegion(new CellRangeAddress(8, 8, 0, 27));
		// 合并电厂名称及机组编号单元格
		sheet.addMergedRegion(new CellRangeAddress(10, 11, 0, 0));
		// 合并指标代码单元格
		sheet.addMergedRegion(new CellRangeAddress(10, 11, 1, 1));
		// 合并组织机构代码单元格
		sheet.addMergedRegion(new CellRangeAddress(10, 11, 2, 2));
		// 合并期末发电设备容量(千瓦)单元格
		sheet.addMergedRegion(new CellRangeAddress(10, 11, 3, 3));
		// 合并其中：供热设备容量(千瓦)单元格
		sheet.addMergedRegion(new CellRangeAddress(10, 11, 4, 4));
		// 合并发电量(万千瓦时)单元格
		sheet.addMergedRegion(new CellRangeAddress(10, 10, 5, 6));
		// 合并平均利用小时(小时)单元格
		sheet.addMergedRegion(new CellRangeAddress(10, 11, 7, 7));
		// 合并平均设备容量(千瓦)单元格
		sheet.addMergedRegion(new CellRangeAddress(10, 11, 8, 8));
		// 合并计算厂用电率的发电量(万千瓦时)单元格
		sheet.addMergedRegion(new CellRangeAddress(10, 11, 9, 9));
		// 合并发电厂用电量(万千瓦时)单元格
		sheet.addMergedRegion(new CellRangeAddress(10, 11, 10, 10));
		// 合并发电厂用电率(%)单元格
		sheet.addMergedRegion(new CellRangeAddress(10, 11, 11, 11));
		// 合并计算发电煤耗的发电量(万千瓦时)单元格
		sheet.addMergedRegion(new CellRangeAddress(10, 11, 12, 12));
		// 合并计算供电煤耗的供电量(万千瓦时)单元格
		sheet.addMergedRegion(new CellRangeAddress(10, 11, 13, 13));
		// 合并发电消耗标准煤量(吨)单元格
		sheet.addMergedRegion(new CellRangeAddress(10, 11, 14, 14));
		// 合并标准煤耗(克/千瓦时)单元格
		sheet.addMergedRegion(new CellRangeAddress(10, 10, 15, 16));
		// 合并发电耗用原煤、燃油和燃气量等单元格
		sheet.addMergedRegion(new CellRangeAddress(10, 10, 17, 19));
		// 合并供热量(吉焦)单元格
		sheet.addMergedRegion(new CellRangeAddress(10, 11, 20, 20));
		// 合并供热燃料消耗单元格
		sheet.addMergedRegion(new CellRangeAddress(10, 10, 21, 23));
		// 合并供热厂用电单元格
		sheet.addMergedRegion(new CellRangeAddress(10, 10, 24, 25));
		// 合并供热标准煤量(吨)单元格
		sheet.addMergedRegion(new CellRangeAddress(10, 11, 26, 26));
		// 合并供热标准煤耗(千克/吉焦)单元格
		sheet.addMergedRegion(new CellRangeAddress(10, 11, 27, 27));

		return sheet;
	}

	/**
	 * 查询报表数据
	 * 
	 * @param time
	 * @return
	 */
	public List<IndicatorMapperReport2> findByTime(Long time) {
		return reportRepository.findByTimeOrderByRowIndexAsc(time);
	}

}
